| Don't tell me what I know or don't know. My newest site right now generates 3 MILLION new visitors a month, its database is probably 100x bigger than this site and yet it performs changes and searches in milliseconds on tables that have more than 50 million entries. Please learn to accept professional criticism in a healthy manner and stop trying to defend everything. I don't need to see the code to know it's inefficient. This site should be able to run flawlessly on a $5 a month hosting plan with the cheapest hardware money can buy. It has barely 200 people on at any one time and the site is VERY simple. The fact is, regardless of what role the hardware is playing on this issue, it's still not properly utilizing the database in an efficient manner and that is why anything that requires any kind of database searching (threads, posts, users online, searching, etc) takes a long time, even when the site is running decently smooth. I've noticed it since I began visiting the site around 2010 (I didn't join because I had an NA and finally joined a year later when I got my TT). Viewing a thread takes 5 seconds to load (slow), but try to search something and here we go: "The search timed out before completing. This is usually because your search is too vague and returns too many results and is common if your search was for only one word. A partial list that was retrieved is displayed below. Your search for blitz returned 4,487 hits in 29.938 seconds" Regardless of it being vague - a search of every post on this site on a properly indexed database with code taking advantage of the indexes shouldn't take more than one second to complete. Example: here's a search on one of my sites for a vague, one word keyword on one of the tables: "Showing rows 0 - 29 (2725864 total, Query took 0.0014 sec)" So you mean to tell me my site takes 1.4 milliseconds to come up with 2.7 MILLION search results, yet yours takes 30 seconds to come up with 4.4K?
|
